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)