Geport-erd-test

Tables (12)

BOOKMARK (Untitled12)

  • BOOKMARK_ID (Key) — Primary key — NOT NULL
  • title (Field)
  • MEMBER_ID (Key2) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • POST_ID (Key3) — Foreign key → POST.POST_ID — NOT NULL

CATEGORY (Untitled2)

  • CATEGORY_ID (Key) — Primary key — NOT NULL
  • name (Field)
  • CATEGORY_ID (Key2) — Foreign key → CATEGORY.CATEGORY_ID — NOT NULL

FAQ (Untitled6)

  • FAQ_ID (Key) — Primary key — NOT NULL
  • title (Field)
  • content (Field2)
  • MEMBER_ID (Key2) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • createdate (Field3)

FOLLOW (Untitled11)

  • FOLLOW_ID (Key) — Primary key — NOT NULL
  • MEMBER_ID (Key2) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • MEMBER_ID (Key3) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • createdate (Field)

LIKE (Untitled4)

  • LIKE_ID (Key) — Primary key — NOT NULL
  • like (Field2)
  • MEMBER_ID (Key2) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • POST_ID (Key3) — Foreign key → POST.POST_ID — NOT NULL

MEMBER (Untitled)

  • MEMBER_ID (Key) — Primary key — NOT NULL
  • name (Field)
  • login_id (Field2)
  • login_pw (Field3)
  • nickname (Field4)
  • authority (Field5)
  • email (Field6)
  • birthdate (Field7)
  • createdate (Field8)

MESSAGE_TO_ADMIN (Untitled10)

  • MESSAGE_TO_ADMIN_ID (Key) — Primary key — NOT NULL
  • title (Field) — varchar
  • create_date (Field2)
  • content (Field3)
  • MEMBER_ID (Key2) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • ADMIN_ID (Key3) — Foreign key → MEMBER.MEMBER_ID — NOT NULL

NOTICE (Untitled8)

  • NOTICE_ID (Key) — Primary key — NOT NULL
  • title (Field)
  • content (Field2)
  • createdate (Field3)
  • MEMBER_ID (Key2) — Foreign key → MEMBER.MEMBER_ID — NOT NULL

POST (Untitled3)

  • POST_ID (Key) — Primary key — NOT NULL
  • title (Field)
  • content (Field2)
  • createdate (Field3)
  • like_count (Field4)
  • replayable (Field5)
  • privacy (Field6)
  • isnotice (Field7)
  • MEMBER_ID (Key3) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • CATEGORY_ID (Key2) — Foreign key → CATEGORY.CATEGORY_ID — NOT NULL

REPLY (Untitled5)

  • REPLY_ID (Key) — Primary key — NOT NULL
  • createdate (Field2) — Primary key
  • content (Field)
  • POST_ID (Key2) — Foreign key → POST.POST_ID — NOT NULL
  • REPLY_ID (Key3) — Foreign key → REPLY.REPLY_ID — NOT NULL
  • createdate (Field22) — Foreign key → REPLY.createdate

REPORT (Untitled9)

  • REPORT_ID (Key) — Primary key — NOT NULL
  • title (Field)
  • content (Field2)
  • createdate (Field3)
  • MEMBER_ID (Key2) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • POST_ID (Key3) — Foreign key → POST.POST_ID — NOT NULL

TAG (Untitled7)

  • TAG_ID (Key) — Primary key — NOT NULL
  • name (Field)
  • POST_ID (Key2) — Foreign key → POST.POST_ID — NOT NULL