cotato

Tables (3)

Application (지원 서류)

  • application_id (Key) — bigint — Primary key — NOT NULL
  • period (Field2) — int
  • part (Field4) — varchar(5)
  • ability (Field5) — int
  • passion (Field6) — int
  • application_time (Field8) — datetime
  • member_id (Key2) — bigint — Foreign key → Member.member_id — NOT NULL

Like (좋아요)

  • like_id (Key) — bigint — Primary key — NOT NULL
  • member_id (Key2) — bigint — Foreign key → Member.member_id — NOT NULL
  • application_id (Key3) — bigint — Foreign key → Application.application_id — NOT NULL

Member (맴버)

  • member_id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(10)
  • age (Field2) — int
  • phone_number (Field3) — varchar(11)
  • role (Field4) — varchar(5)