Full Stack Web-Project
Tables (13)
answer
- id — int — Primary key — NOT NULL
- content — tinytext — NOT NULL
- create_date — datetime(6)
- inquiry_id — int — Foreign key → inquiry.id
- member_id — int — Foreign key → member.id
board
- id — int — Primary key — NOT NULL
- board_type — enum('AD','BOARD','NOTICE')
- content — tinytext — NOT NULL
- create_date — datetime(6)
- title — varchar(255) — NOT NULL
- memberid — int — Foreign key → member.id
cart
- id — int — Primary key — NOT NULL
- memberid — int — Foreign key → member.id — NOT NULL
discount
- id — int — Primary key — NOT NULL
- expire_at — datetime(6)
- rate — double — NOT NULL
- start_at — datetime(6)
- discount_name — varchar(255) — NOT NULL
favorite
- id — int — Primary key — NOT NULL
- discountid — int — Foreign key → discount.id
- productid — int — Foreign key → product.id
- memberid — int — Foreign key → member.id — NOT NULL
imagefile
- id — bigint — Primary key — NOT NULL
- file_name — varchar(255)
- file_path — varchar(255)
- upload_at — datetime(6)
- url — varchar(255)
- uuid — varchar(255)
inquiry
- id — int — Primary key — NOT NULL
- content — varchar(255) — NOT NULL
- create_date — datetime(6)
- title — varchar(255) — NOT NULL
- answer_id — int — Foreign key → answer.id
- memberid — int — Foreign key → member.id
member
- id — int — Primary key — NOT NULL
- create_date — datetime(6)
- email — varchar(255) — NOT NULL
- first_name — varchar(100)
- last_name — varchar(100)
- oauth — enum('BOARD','GOOGLE','KAKAO')
- password — varchar(255) — NOT NULL
- role — enum('ADMIN','USER')
- username — varchar(255) — NOT NULL
notice
- id — int — Primary key — NOT NULL
- content — varchar(255) — NOT NULL
- create_date — datetime(6)
- title — varchar(255) — NOT NULL
- member_id — int — Foreign key → member.id
product
- id — int — Primary key — NOT NULL
- category — longtext
- price — varchar(255) — NOT NULL
- product_name — varchar(255) — NOT NULL
- discountid — int — Foreign key → discount.id
- product_detail_id — int — Foreign key → product_detail.id
- content — longtext
- image_url — varchar(255)
- favoriteid — int — Foreign key → favorite.id
- cartid — int — Foreign key → cart.id
product_detail
- id — int — Primary key — NOT NULL
- content — varchar(255)
- product_id — int — Foreign key → product.id
purchase
- id — int — Primary key — NOT NULL
- method — enum('CARD','CASH')
- status — enum('FINISHED','PENDING')
- time — datetime(6)
- total_amount — int — NOT NULL
- member_id — int — Foreign key → member.id
- payment_info — varchar(255) — NOT NULL
reply
- id — int — Primary key — NOT NULL
- content — tinytext — NOT NULL
- boardid — int — Foreign key → board.id
- member_id — int — Foreign key → member.id