$$config title: 지금이약 DB keywords: - DB $$ ## ?️ ERD ![img](https://i.imgur.com/lE3Go7K.jpg)
## ?️ 테이블 정의서 ### ? 회원 - Site-User : 회원 ```sql CREATE TABLE `site_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_date` datetime(6) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `last_login_date` datetime(6) DEFAULT NULL, `login_id` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `address_id` bigint(20) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, `authority` int(11) DEFAULT NULL, `is_temp` bit(1) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UK_8vlkw482t3gpnebxcm03ywk9p` (`email`), UNIQUE KEY `UK_f7tg8kk7gr5fi625rh7gosyxf` (`login_id`), KEY `FKfswbvv7kue8dd9p8ai26u6cel` (`address_id`), CONSTRAINT `FKfswbvv7kue8dd9p8ai26u6cel` FOREIGN KEY (`address_id`) REFERENCES `address` (`id`) ) ```
- Address : 주소 ```sql CREATE TABLE `address` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `main_address` varchar(50) DEFAULT NULL, `sub_address` varchar(50) DEFAULT NULL, `zone_code` int(11) DEFAULT NULL, `create_date` datetime(6) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, PRIMARY KEY (`id`) ) ```
- Social-Account : 소셜 로그인 ```sql CREATE TABLE `social_account` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `parent_id` bigint(20) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `provider_id` varchar(255) DEFAULT NULL, `create_date` datetime(6) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, `provider` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UK_bdg9pato262jft09dhwe00wxh` (`provider_id`), KEY `FKc6kyxocjekhjgofpkmx6ydqcf` (`parent_id`), CONSTRAINT `FKc6kyxocjekhjgofpkmx6ydqcf` FOREIGN KEY (`parent_id`) REFERENCES `site_user` (`id`) ) ```

### ? 상품 - Product : 상품 ```sql CREATE TABLE `product` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `product_category_id` bigint(20) DEFAULT NULL, `description` text DEFAULT NULL, `hit` bigint(20) DEFAULT NULL, `name` varchar(50) DEFAULT NULL, `price` int(11) NOT NULL, `quantity` int(11) DEFAULT NULL, `thumbnail_img_id` bigint(20) DEFAULT NULL, `create_date` datetime(6) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, `inventory` bigint(20) DEFAULT NULL, `detail_img_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FKcwclrqu392y86y0pmyrsi649r` (`product_category_id`), KEY `FKs63tm1481bynt8weiywshyfnc` (`thumbnail_img_id`), KEY `FK51nimxw16d8se935lewjuprw5` (`detail_img_id`), CONSTRAINT `FK51nimxw16d8se935lewjuprw5` FOREIGN KEY (`detail_img_id`) REFERENCES `gen_file` (`id`), CONSTRAINT `FKcwclrqu392y86y0pmyrsi649r` FOREIGN KEY (`product_category_id`) REFERENCES `product_category` (`id`), CONSTRAINT `FKs63tm1481bynt8weiywshyfnc` FOREIGN KEY (`thumbnail_img_id`) REFERENCES `gen_file` (`id`) ) ```
- Product-Category : 상품 카테고리 ```sql CREATE TABLE `product_category` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_date` datetime(6) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, PRIMARY KEY (`id`) ) ```
- Product-Review : 상품 리뷰 ```sql CREATE TABLE `product_review` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `product_id` bigint(20) DEFAULT NULL, `reviewer_id` bigint(20) DEFAULT NULL, `create_date` datetime(6) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, `content` text DEFAULT NULL, `star_rating` int(11) DEFAULT NULL, `review_img_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UK_krjsswds5nk5x6a8utivkqib6` (`review_img_id`), KEY `FKkaqmhakwt05p3n0px81b9pdya` (`product_id`), KEY `FKjuhddo06brm13fkcnfjgja02t` (`reviewer_id`), CONSTRAINT `FK1w70k389n2eoje22ghgpkpedq` FOREIGN KEY (`review_img_id`) REFERENCES `gen_file` (`id`), CONSTRAINT `FKjuhddo06brm13fkcnfjgja02t` FOREIGN KEY (`reviewer_id`) REFERENCES `site_user` (`id`), CONSTRAINT `FKkaqmhakwt05p3n0px81b9pdya` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`) ) ```
- Survey : 설문 ```sql CREATE TABLE `survey` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_date` datetime(6) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, `question` varchar(255) DEFAULT NULL, `nutrient_category_id` bigint(20) DEFAULT NULL, `surveyee_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FKprc564pnr1fwhfx8lfa0r2axx` (`nutrient_category_id`), KEY `FKjudsiyahw8g6oe9sgs4iy4f1x` (`surveyee_id`), CONSTRAINT `FKjudsiyahw8g6oe9sgs4iy4f1x` FOREIGN KEY (`surveyee_id`) REFERENCES `site_user` (`id`), CONSTRAINT `FKprc564pnr1fwhfx8lfa0r2axx` FOREIGN KEY (`nutrient_category_id`) REFERENCES `nutrient_category` (`id`) ) ```
- Survey Answer: 설문 답변 ```sql CREATE TABLE `survey_answer` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_date` datetime(6) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, `answer_text` varchar(255) DEFAULT NULL, `survey_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK2orahwrsoh3de2b3p1a7pv09w` (`survey_id`), CONSTRAINT `FK2orahwrsoh3de2b3p1a7pv09w` FOREIGN KEY (`survey_id`) REFERENCES `survey` (`id`) ) ```

### ? 성분 - Nutrient : 성분 ```sql CREATE TABLE `nutrient` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_date` datetime(6) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, `daily_intake` varchar(255) DEFAULT NULL, `efficacy` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ```
- Nutrient-Category : 성분 카테고리 ```sql CREATE TABLE `nutrient_category` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_date` datetime(6) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, `category_name` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ```
- Nutrient-Caution : 성분 주의사항 ```sql CREATE TABLE `nutrient_caution` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_date` datetime(6) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, `caution` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ```
- Nutrient-Answer ```sql CREATE TABLE `nutrient_answer` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_date` datetime(6) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, `score` double DEFAULT NULL, `answer_id` bigint(20) DEFAULT NULL, `nutrient_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FKdjmtn99lqkw5b2diia5k0tggd` (`answer_id`), KEY `FKo5o5fi0i8bx3obxi3m9t2g9ek` (`nutrient_id`), CONSTRAINT `FKdjmtn99lqkw5b2diia5k0tggd` FOREIGN KEY (`answer_id`) REFERENCES `survey_answer` (`id`), CONSTRAINT `FKo5o5fi0i8bx3obxi3m9t2g9ek` FOREIGN KEY (`nutrient_id`) REFERENCES `nutrient` (`id`) ) ```

### ? 구매 - Cart : 장바구니 ```sql CREATE TABLE `cart` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_date` datetime(6) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, `owner_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FKrdq3efc1oxasyakofgt76d4a5` (`owner_id`), CONSTRAINT `FKrdq3efc1oxasyakofgt76d4a5` FOREIGN KEY (`owner_id`) REFERENCES `site_user` (`id`) ) ```
- Cart-Item : 장바구니 내역 ```sql CREATE TABLE `cart_item` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `cart_id` bigint(20) DEFAULT NULL, `create_date` datetime(6) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, `count` int(11) NOT NULL, `product_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK1uobyhgl1wvgt1jpccia8xxs3` (`cart_id`), KEY `FKjcyd5wv4igqnw413rgxbfu4nv` (`product_id`), CONSTRAINT `FK1uobyhgl1wvgt1jpccia8xxs3` FOREIGN KEY (`cart_id`) REFERENCES `cart` (`id`), CONSTRAINT `FKjcyd5wv4igqnw413rgxbfu4nv` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`) ) ```
- Purchace : 구매 ```sql CREATE TABLE `purchase` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `purchaser_id` bigint(20) DEFAULT NULL, `create_date` datetime(6) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, `purchase_id` varchar(255) DEFAULT NULL, `purchase_state` smallint(6) DEFAULT NULL, `purchase_name` varchar(255) DEFAULT NULL, `delivery_request` varchar(255) DEFAULT NULL, `purchaser_name` varchar(255) DEFAULT NULL, `purchaser_phone_number` varchar(255) DEFAULT NULL, `receiver_name` varchar(255) DEFAULT NULL, `receiver_phone_number` varchar(255) DEFAULT NULL, `receiver_address_id` bigint(20) DEFAULT NULL, `total_amount` int(11) DEFAULT NULL, `method` varchar(255) DEFAULT NULL, `pay_date` datetime(6) DEFAULT NULL, `payment_key` varchar(255) DEFAULT NULL, `supplied_amount` int(11) DEFAULT NULL, `vat` int(11) DEFAULT NULL, `payment_detail` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK14y6eahkvd6x65fl1t1wn4kxy` (`purchaser_id`), KEY `FK34qoswfg15dtnctn7s1a7h0xn` (`receiver_address_id`), CONSTRAINT `FK14y6eahkvd6x65fl1t1wn4kxy` FOREIGN KEY (`purchaser_id`) REFERENCES `site_user` (`id`), CONSTRAINT `FK34qoswfg15dtnctn7s1a7h0xn` FOREIGN KEY (`receiver_address_id`) REFERENCES `address` (`id`) ) ```
- Purchace-Item : 구매 목록 ```sql CREATE TABLE `purchase_item` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_date` datetime(6) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, `count` int(11) DEFAULT NULL, `product_id` bigint(20) DEFAULT NULL, `purchase_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FKq69apam78dbi0cggl37ge6auf` (`product_id`), KEY `FK1mncc5yaore1sibgpj3jc4a7u` (`purchase_id`), CONSTRAINT `FK1mncc5yaore1sibgpj3jc4a7u` FOREIGN KEY (`purchase_id`) REFERENCES `purchase` (`id`), CONSTRAINT `FKq69apam78dbi0cggl37ge6auf` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`) ) ```
- Cash-log ```sql CREATE TABLE `cash_log` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_date` datetime(6) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, `purchase_id` bigint(20) DEFAULT NULL, `total_amount` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FKgxq5g0jaukqsbj0me6om8pss4` (`purchase_id`), CONSTRAINT `FKgxq5g0jaukqsbj0me6om8pss4` FOREIGN KEY (`purchase_id`) REFERENCES `purchase` (`id`) ) ```

### ? 공지사항 - Notice : 공지사항 ```sql CREATE TABLE `notice` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `content` varchar(255) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `author_id` bigint(20) DEFAULT NULL, `category_id` bigint(20) DEFAULT NULL, `create_date` datetime(6) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, `hit` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK13jpuj12bp7vqg9bv7778md97` (`author_id`), KEY `FKa7i9o4bnwi4ojfour0obewnmi` (`category_id`), CONSTRAINT `FK13jpuj12bp7vqg9bv7778md97` FOREIGN KEY (`author_id`) REFERENCES `site_user` (`id`), CONSTRAINT `FKa7i9o4bnwi4ojfour0obewnmi` FOREIGN KEY (`category_id`) REFERENCES `notice_category` (`id`) ) ```
- Notice-Category : 공지사항 카테고리 ```sql CREATE TABLE `notice_category` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `create_date` datetime(6) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, PRIMARY KEY (`id`) ) ```
- Notice-Comment : 공지사항 댓글 ```sql CREATE TABLE `notice_comment` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `author_id` bigint(20) DEFAULT NULL, `notice_id` bigint(20) DEFAULT NULL, `content` varchar(255) DEFAULT NULL, `create_date` datetime(6) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FKcc328elmb0h1u1a3yr10cut8u` (`author_id`), KEY `FKax7qcww5twiq84y8dvvpaketx` (`notice_id`), CONSTRAINT `FKax7qcww5twiq84y8dvvpaketx` FOREIGN KEY (`notice_id`) REFERENCES `notice` (`id`), CONSTRAINT `FKcc328elmb0h1u1a3yr10cut8u` FOREIGN KEY (`author_id`) REFERENCES `site_user` (`id`) ) ```

### ? 커뮤니티 - Board : 게시판 ```sql CREATE TABLE `board` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `author_id` bigint(20) DEFAULT NULL, `content` text DEFAULT NULL, `create_date` datetime(6) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, `subject` varchar(300) DEFAULT NULL, `hit` bigint(20) DEFAULT NULL, `vote` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK82o8y2om62a216rwkuf5hc738` (`author_id`), CONSTRAINT `FK82o8y2om62a216rwkuf5hc738` FOREIGN KEY (`author_id`) REFERENCES `site_user` (`id`) ) ```
- Board-Comment : 게시판 댓글 ```sql CREATE TABLE `board_comment` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `author_id` bigint(20) DEFAULT NULL, `board_id` bigint(20) DEFAULT NULL, `content` text DEFAULT NULL, `create_date` datetime(6) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK6labty61pi9gx5966nfhi1b6j` (`author_id`), KEY `FKke01v1gkigv4065kfl3aavje6` (`board_id`), CONSTRAINT `FK6labty61pi9gx5966nfhi1b6j` FOREIGN KEY (`author_id`) REFERENCES `site_user` (`id`), CONSTRAINT `FKke01v1gkigv4065kfl3aavje6` FOREIGN KEY (`board_id`) REFERENCES `board` (`id`) ) ```
- Board-Recomment : 게시판 대댓글 ```sql CREATE TABLE `board_recomment` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `author_id` bigint(20) DEFAULT NULL, `comment_id` bigint(20) DEFAULT NULL, `content` text DEFAULT NULL, `create_date` datetime(6) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FKdsi8kmpad2gl9y6qyevk29f98` (`author_id`), KEY `FKldkb06ncrmkyd6gxcvdnflo7u` (`comment_id`), CONSTRAINT `FKdsi8kmpad2gl9y6qyevk29f98` FOREIGN KEY (`author_id`) REFERENCES `site_user` (`id`), CONSTRAINT `FKldkb06ncrmkyd6gxcvdnflo7u` FOREIGN KEY (`comment_id`) REFERENCES `board_comment` (`id`) ) ```

### ? 문의하기 - Inquiry : 문의 ```sql CREATE TABLE `inquiry` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `inquirer_id` bigint(20) DEFAULT NULL, `create_date` datetime(6) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, `content` varchar(255) DEFAULT NULL, `subject` varchar(255) DEFAULT NULL, `email` bit(1) NOT NULL, `category` varchar(255) DEFAULT NULL, `state` bit(1) NOT NULL, `img_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FKj0yuprn6dx2qv0ws0ld6ctrwe` (`inquirer_id`), KEY `FKtyowd8cwfca0aymy8d4uwp85` (`img_id`), CONSTRAINT `FKj0yuprn6dx2qv0ws0ld6ctrwe` FOREIGN KEY (`inquirer_id`) REFERENCES `site_user` (`id`), CONSTRAINT `FKtyowd8cwfca0aymy8d4uwp85` FOREIGN KEY (`img_id`) REFERENCES `gen_file` (`id`) ) ```
- Inquiry-Answer : 문의 답변 ```sql CREATE TABLE `inquiry_answer` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_date` datetime(6) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, `content` varchar(255) DEFAULT NULL, `author_id` bigint(20) DEFAULT NULL, `inquiry_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FKba8ybqn1jc08tspf6jfphcuky` (`author_id`), KEY `FK3irhermk3cm96u0y7oiv3ya4p` (`inquiry_id`), CONSTRAINT `FK3irhermk3cm96u0y7oiv3ya4p` FOREIGN KEY (`inquiry_id`) REFERENCES `inquiry` (`id`), CONSTRAINT `FKba8ybqn1jc08tspf6jfphcuky` FOREIGN KEY (`author_id`) REFERENCES `site_user` (`id`) ) ```
- FAQ : 자주 묻는 문의 ```sql CREATE TABLE `faq` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_date` datetime(6) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, `content` varchar(255) DEFAULT NULL, `question` varchar(255) DEFAULT NULL, `category` varchar(255) DEFAULT NULL, `answer` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ```

### ? 이미지 - Genfile ```sql CREATE TABLE `gen_file` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_date` datetime(6) DEFAULT NULL, `date` varchar(255) DEFAULT NULL, `ext` varchar(255) DEFAULT NULL, `primary_path` varchar(255) DEFAULT NULL, `secondary_path` varchar(255) DEFAULT NULL, `uploader` varchar(255) DEFAULT NULL, `modify_date` datetime(6) DEFAULT NULL, `product_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FKrlgkjrlng6nmtiu4sxa0eqmb6` (`product_id`), CONSTRAINT `FKrlgkjrlng6nmtiu4sxa0eqmb6` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`) ) ```

--- ??감사합니다??