shallwe refactor
Tables (9)
AUTH (Untitled4)
- auth_id (Key) — int — Primary key — NOT NULL
- email (Field) — varchar(128)
- auth_number (Field2) — int
CATEGORY (카테고리)
- category_id (PK) — int — Primary key — NOT NULL
- name (카테고리이름) — varchar(128)
COMMENT (CopyOf게시글)
- comment_id (PK) — int — Primary key — NOT NULL
- article_id (PK2) — int — Foreign key → Order.order_id — NOT NULL
- user_id (PK3) — int — Foreign key → USER.id — NOT NULL
- title (아이디) — varchar(128)
- writer (Field) — varchar(128)
- content (Field2) — varchar(128)
- create_time (Field3) — datetime
- status (Field4) — int
Like (Untitled2)
- no (Key) — int — Primary key — NOT NULL
- user_id (PK) — int — Foreign key → USER.id — NOT NULL
- article_id (PK2) — int — Foreign key → Order.order_id — NOT NULL
Order (게시글)
- order_id (PK) — int — Primary key — NOT NULL
- category_id (PK2) — int — Foreign key → CATEGORY.category_id — NOT NULL
- user_id (PK3) — int — Foreign key → USER.id — NOT NULL
- title (아이디) — varchar(128)
- address (비밀번호) — varchar(128)
- description (이메일) — varchar(128)
- min_price (이름) — int
- sum_price (닉네임) — int
- writer (Field7) — varchar(128)
- image (신뢰점수) — longtext
- url_link (Field8) — varchar(200)
- open_link (Field9) — varchar(200)
- temp (생성일) — int
- tag (Field4) — varchar(128)
- like_num (Field5) — int
- comment_num (Field6) — int
- end_time (Field) — datetime
- create_time (Field2) — datetime
- status (Field3) — int
Order_Tag
- article_id (PK) — int — Foreign key → Order.order_id — NOT NULL
- tag_id (Key) — INT — Foreign key → TAG.tag_id — NOT NULL
PARTICIPANT (Untitled3)
- no (Key) — int — Primary key — NOT NULL
- user_id (PK) — int — Foreign key → USER.id — NOT NULL
- article_id (PK2) — int — Foreign key → Order.order_id — NOT NULL
- title (Field) — varchar(128)
- url (Field5) — varchar(2000)
- writer (Field6) — varchar(128)
- price (Field2) — int
- description (Field3) — varchar(128)
- create_time (Field4) — datetime
- status (Field7) — int
TAG (Untitled)
- tag_id (Key) — INT — Primary key — NOT NULL
- name (Unique) — varchar(128)
USER (회원)
- id (PK) — int — Primary key — NOT NULL
- email (Field) — varchar(128)
- password (비밀번호) — varchar(128)
- nickname (닉네임) — varchar(128)
- address (주소) — varchar(128)
- user_point (신뢰점수) — int
- grade (등급) — int
- birthday (생일) — date
- profile_image (Field2) — longtext
- introduce (소개) — varchar(2000)
- create_time (생성일) — datetime
- status (Field5) — int