main-project-team-4
Tables (12)
CategoryL (category_large)
- ID (id) — Primary key — NOT NULL
- NAME (name)
CategoryM (category_mid)
- ID (id) — Primary key — NOT NULL
- NAME (name)
- PARENT (parent) — Foreign key → CategoryL.ID — NOT NULL
Chat (chat)
- ID (id) — Primary key — NOT NULL
- CONTENT (content)
- ROOM_ID (room_id) — Foreign key → ChatRoom.ID — NOT NULL
ChatRoom (chat_room)
- ID (id) — Primary key — NOT NULL
- SELLER_ID (seller_id) — Foreign key → Member.ID — NOT NULL
- CONSUMER_ID (consumer_id) — Foreign key → Member.ID — NOT NULL
- ITEM_ID (item_id) — Foreign key → Item.ID — NOT NULL
Follow (follow)
- ID (id) — Primary key — NOT NULL
- MEMBER_ID (member_id) — Foreign key → Member.ID — NOT NULL
- SHOP_ID (shop_id) — Foreign key → Shop.ID — NOT NULL
Item (item)
- ID (id) — Primary key — NOT NULL
- NAME (name)
- PRICE (price)
- COMMENT (comment)
- IMAGE_URL (image_url)
- CREATED_AT (createdAt)
- STATE (state)
- LOCATION_ID (location_id) — Foreign key → Location.ID — NOT NULL
- SHOP_ID (shop_id) — Foreign key → Shop.ID — NOT NULL
- CATEGORY_MID_ID (category_mid_id) — Foreign key → CategoryM.ID — NOT NULL
Location (location)
- ID (id) — Primary key — NOT NULL
- STATE (state)
- CITY (city)
- ADDRESS_ONE (address_one)
- MEMBER_ID (member_id) — Foreign key → Member.ID — NOT NULL
Member (member)
- ID (id) — Primary key — NOT NULL
- USERNAME (username)
- PASSWORD (password)
- NICKNAME (nickname)
- PHONE_NUM (phone_num)
- IMAGE (image)
Review (review)
- ID (id) — Primary key — NOT NULL
- COMMENT (comment)
- RATING (rating)
- SHOP_ID (shop_id) — Foreign key → Shop.ID — NOT NULL
- MEMBER_ID (member_id) — Foreign key → Member.ID — NOT NULL
- ITEM_ID (item_id) — Foreign key → Item.ID — NOT NULL
Shop (shop)
- ID (id) — Primary key — NOT NULL
- INTRO (intro)
- SELLER_ID (seller_id) — Foreign key → Member.ID — NOT NULL
- ITEM_LIST (item_list)
- REVIEW_LIST (review_list)
- RATING_TOTAL (star_avg)
Trade (trade)
- ID (id) — Primary key — NOT NULL
- MEMBER_ID (member_id) — Foreign key → Member.ID — NOT NULL
- SELLER_ID (seller_id) — Foreign key → Member.ID — NOT NULL
- ITEM_ID (item_id) — Foreign key → Item.ID — NOT NULL
Wish (wish)
- ID (id) — Primary key — NOT NULL
- ITEM_ID (item_id) — Foreign key → Member.ID — NOT NULL
- MEMBER_ID (member_id) — Foreign key → Item.ID — NOT NULL