danggeun
Tables (6)
chatroom (Untitled6)
- id (Key) — int — Primary key — NOT NULL
- product_id (Key2) — int — Foreign key → product.id — NOT NULL
district (Untitled3)
- id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar
- city (Field2) — varchar
image (Untitled4)
- id (Key) — int — Primary key — NOT NULL
- type (Field) — varchar
- url (Field2) — varchar
message (Untitled7)
- id (Key) — int — Primary key — NOT NULL
- id (Key3) — int — Foreign key → chatroom.id — NOT NULL
- id (Key32) — int — Foreign key — NOT NULL
- content (Field) — varchar
- messagedate (Field2) — timestamp
- uid (Key2) — int — Foreign key → users.uid — NOT NULL
- district_id (Key22) — int — Foreign key → users.district_id — NOT NULL
product (Untitled)
- id (Key) — int — Primary key — NOT NULL
- users_uid (Key2) — int — Foreign key → users.uid — NOT NULL
- district_id (Key22) — int — Foreign key → users.district_id — NOT NULL
- image_id (Key3) — int — Foreign key → image.id — NOT NULL
- title (Field) — varchar
- price (Field2) — int
- text (Field3) — varchar
- image_url (Field4) — varchar
- created_time (Field5) — timestamp
- status (Field6) — boolean
- views (Field7) — int
users (Untitled2)
- uid (Key) — int — Primary key — NOT NULL
- district_id (Key2) — int — Foreign key → district.id — NOT NULL
- id (Field) — varchar
- name (Field2) — varchar
- created_date (Field3) — timestamp
- email (Field4) — varchar
- sex (Field5) — char
- order_history (Field6) — varchar
- cellphone_num (Field7) — varchar