SUBPJT_욕항
테이블 (8)
ARTICLE (게시글)
- article_id (PK) — int — 기본 키 — NOT NULL
- category_id (PK2) — int — 외래 키 → CATEGORY.category_id — NOT NULL
- user_id (PK3) — int — 외래 키 → USER.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
AUTH (Untitled4)
- auth_id (Key) — int — 기본 키 — NOT NULL
- email (Field) — varchar(128)
- auth_number (Field2) — int
CATEGORY (카테고리)
- category_id (PK) — int — 기본 키 — NOT NULL
- name (카테고리이름) — varchar(128)
COMMENT (CopyOf게시글)
- comment_id (PK) — int — 기본 키 — NOT NULL
- article_id (PK2) — int — 외래 키 → ARTICLE.article_id — NOT NULL
- user_id (PK3) — int — 외래 키 → USER.user_id — NOT NULL
- title (아이디) — varchar(128)
- writer (Field) — varchar(128)
- content (Field2) — varchar(128)
- create_time (Field3) — datetime
- status (Field4) — int
LIKE_TABLE (Untitled2)
- no (Key) — int — 기본 키 — NOT NULL
- user_id (PK) — int — 외래 키 → USER.user_id — NOT NULL
- article_id (PK2) — int — 외래 키 → ARTICLE.article_id — NOT NULL
PARTICIPANT (Untitled3)
- no (Key) — int — 기본 키 — NOT NULL
- user_id (PK) — int — 외래 키 → USER.user_id — NOT NULL
- article_id (PK2) — int — 외래 키 → ARTICLE.article_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 — 기본 키 — NOT NULL
- article_id (PK) — int — 외래 키 → ARTICLE.article_id — NOT NULL
- name (Field) — varchar(128)
USER (회원)
- user_id (PK) — int — 기본 키 — NOT NULL
- email (Field) — varchar(128)
- password (비밀번호) — varchar(128)
- nickname (닉네임) — varchar(128)
- address (주소) — varchar(128)
- user_point (신뢰점수) — int
- grade (Field4) — int
- birthday (생일) — date
- profile_image (Field2) — longtext
- introduce (Field3) — varchar(2000)
- create_time (생성일) — datetime
- status (Field5) — int