fleamarket
Tables (10)
Category (Untitled9)
- category_id (Key) — bigint(20) — Primary key — NOT NULL
- name (Field) — varchar(10)
Chat (Untitled5)
- chat_id (Key) — bigint(20) — Primary key — NOT NULL
- flea_id (Key3) — bigint(20) — Foreign key → Flea.flea_id — NOT NULL
- user_id (Key2) — bigint(20) — Foreign key → User.user_id — NOT NULL
- create_date (Field) — date
Chat_Comment (Untitled6)
- chat_comment_id (Key) — bigtint(20) — Primary key — NOT NULL
- chat_id (Key2) — bigint(20) — Foreign key → Chat.chat_id — NOT NULL
- user_id (Key3) — bigint(20) — Foreign key → User.user_id — NOT NULL
- create_date (Field2) — date
- content (Field) — text
- isview (Field3) — boolean
Flea (Untitled2)
- flea_id (Key) — bigint(20) — Primary key — NOT NULL
- user_id (Key2) — bigint(20) — Foreign key → User.user_id — NOT NULL
- title (Field) — varchar(25)
- content (Field2) — text
- price (Field3) — integer
- views (Field4) — integer
- create_date (Field5) — date
Flea_Category (Untitled10)
- flea_category_id (Key) — bigint(20) — Primary key — NOT NULL
- flea_id (Key2) — bigint(20) — Foreign key → Flea.flea_id — NOT NULL
- category_id (Key3) — bigint(20) — Foreign key → Category.category_id — NOT NULL
Flea_Img (Untitled8)
- flea_img_id (Key) — bigint(20) — Primary key — NOT NULL
- flea_id (Key2) — bigint(20) — Foreign key → Flea.flea_id — NOT NULL
- path (Field) — varchar(256)
Flea_Like (Untitled3)
- flea_like_id (Key) — bigint(20) — Primary key — NOT NULL
- user_id (Key2) — bigint(20) — Foreign key → User.user_id — NOT NULL
- flea_id (Key3) — bigint(20) — Foreign key → Flea.flea_id — NOT NULL
- create_date (Field) — date
Place (Untitled7)
- place_id (Key) — bigint(20) — Primary key — NOT NULL
- sido (Field) — varchar(4)
- gugun (Field2) — varchar(17)
- dong (Field3) — varchar(26)
User (Untitled)
- user_id (Key) — bigint(20) — Primary key — NOT NULL
- name (Field) — varchar(20)
- password (Field2) — varchar(256)
- create_date (Field3) — date
User_Place (Untitled4)
- user_place_id (Key) — bigint(20) — Primary key — NOT NULL
- create_date (Field) — date
- place_id (Key2) — bigint(20) — Foreign key → Place.place_id — NOT NULL
- user_id (Key3) — bigint(20) — Foreign key → User.user_id — NOT NULL