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