side_project

Tables (3)

AUTHORITY (Untitled2)

  • authority_seq (Key) — Primary key — NOT NULL
  • authority (Field) — 권한 코드
  • authority_name (Field2) — 권한명

MEMBER (Untitled)

  • member_seq (Key) — Primary key — NOT NULL
  • id (Field) — 아이디
  • pwd (Field2) — 비밀번호
  • reg_date (Field3) — 가입일
  • del_date (Field5) — 탈퇴일

MEMBER_AUTHORITY (Untitled3)

  • Field
  • member_seq (Key) — Foreign key → MEMBER.member_seq — NOT NULL
  • authority_seq (Key2) — Foreign key → AUTHORITY.authority_seq — NOT NULL