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