SUB_PJT2
Tables (9)
like_list (Untitled4)
- no (Key) — int — Primary key — NOT NULL
- pid (Key2) — int — Foreign key → post_list.pid — NOT NULL
- uid (Key3) — int — Foreign key → user.uid — NOT NULL
- email (Field2) — varchar
- cart (Field) — int
notice (Untitled5)
- nid (Key) — int — Primary key — NOT NULL
- title (Field) — varchar
- content (Field2) — varchar
- visit (Field3) — int
- create_date (Field4) — datetime
pack (Untitled6)
- packno (Key) — int — Primary key — NOT NULL
- email (Field) — varchar
- price (Field2) — int
- cnt (Field3) — int
post_list (Untitled3)
- pid (Key) — int — Primary key — NOT NULL
- uid (Key2) — int — Foreign key → user.uid — NOT NULL
- email (Field) — varchar
- title (Field2) — varchar
- location (Field3) — varchar
- imgurl (Field4) — varchar
- price (Field5) — int
- sdate (Field6) — date
- edate (Field7) — date
- company_info (Field8) — varchar
- detail (Field9) — varchar
- flag (Field10) — int
- activity (Field11) — varchar
- create_date (Field12) — datetime
- likecnt (Field13) — int
purchase (Untitled7)
- purid (Key) — int — Primary key — NOT NULL
- pid (Field) — int
- puse (Field2) — int
- email (Field3) — varchar
- packno (Field4) — int
- serialno (Field5) — varchar
- seller (Field6) — varchar
- title (Field7) — varchar
- sdate (Field8) — date
- edate (Field9) — date
- location (Field10) — varchar
- price (Field11) — price
- img (Field12) — Longtext
reply_list (Untitled2)
- rid (Key) — int — Primary key — NOT NULL
- uid (Key2) — int — Foreign key → user.uid — NOT NULL
- pid (Key3) — int — Foreign key → post_list.pid — NOT NULL
- create_date (Field) — datetime
review (Untitled9)
- rvid (Key) — int — Primary key — NOT NULL
- pid (Field) — int
- email (Field2)
tag (Untitled8)
- tid (Key) — int — Primary key — NOT NULL
- pid (Field) — int
- tagname (Field2) — varchar
user (Untitled)
- uid (Key) — int — Primary key — NOT NULL
- email (Field) — varchar
- nickname (Field2) — varchar
- password (Field3) — varchar
- name (Field4) — varchar
- imgurl (Field5) — varchar
- create_date (Field6) — datetime
- check_type (Field7) — varchar
- clocation (Field8) — varchar
- cphone (Field9) — varchar