giggle

Tables (25)

Account (계정)

  • account_id (ㄹ) — Primary key — NOT NULL
  • login_id (Field)
  • password (Field2)
  • name (Field11)
  • employee_no (Field3)
  • birthday (Field4)
  • phone (Field5)
  • email (Field6)
  • join_date (Field7)
  • left_date (Field8)
  • address (Field9)
  • introduction (Field10)
  • part (Field12)
  • duty (Field13)
  • status (Field15)
  • work (Field16)
  • role_id (Key) — Foreign key → Role.role_id — NOT NULL
  • attach_id (Key2) — Foreign key → Attach.attach_id — NOT NULL
  • created_by (Field14)
  • created_at (Field17)

Account_Team (Untitled2)

  • team_id (Key) — Foreign key → Team.team_id — NOT NULL
  • account_id (ㄹ) — Foreign key → Account.account_id — NOT NULL

Annual (Untitled28)

  • annual_id (Key) — Primary key — NOT NULL
  • created_by (Field4)
  • created_at (Field5)
  • total_annual (Field)
  • reamining_annual (Field2)

Annual_History (CopyOfUntitled28)

  • annul_history_id (Key) — Primary key — NOT NULL
  • title (Field)
  • type (Field2)
  • division (Field3)
  • created_by (Field4)
  • created_at (Field5)
  • annual_id (Key2) — Foreign key → Annual.annual_id — NOT NULL
  • vacation_id (Key3) — Foreign key → Vacation.vacation_id — NOT NULL

Attach (Untitled4)

  • attach_id (Key) — Primary key — NOT NULL
  • filePath (Field)
  • fileName (Field2)

Comment (Untitled6)

  • comment_id (Key) — Primary key — NOT NULL
  • content (Field)
  • created_by (Field2)
  • created_at (Field3)

Comment_King (Untitled26)

  • photo_comment_king_id (Key) — Primary key — NOT NULL
  • comment_count (Field)
  • account_id (ㄹ) — Foreign key → Account.account_id — NOT NULL

Event (Untitled13)

  • event_id (Key) — Primary key — NOT NULL
  • title (Field)
  • type (Field2)
  • content (Field3)
  • start_date (Field4)
  • end_date (Field5)
  • is_all_day (Field6)
  • start_time (Field7)
  • end_time (Field8)
  • created_by (Field9)
  • created_at (Field10)

Nicedain (Untitled31)

  • nicedain_id (Key) — Primary key — NOT NULL
  • account_id (ㄹ) — Foreign key → Account.account_id — NOT NULL
  • date (Field)

Notice (Untitled5)

  • notice_id (Key) — Primary key — NOT NULL
  • title (Field)
  • content (Field2)
  • created_by (Field4)
  • created_at (Field5)
  • attach_id (Key2) — Foreign key → Attach.attach_id — NOT NULL

Notice_Comment (Untitled7)

  • notice_id (Key) — Foreign key → Notice.notice_id — NOT NULL
  • comment_id (Key2) — Foreign key → Comment.comment_id — NOT NULL

Notice_Like (Untitled8)

  • notice_id (Key) — Foreign key → Notice.notice_id — NOT NULL
  • account_id (ㄹ) — Foreign key → Account.account_id — NOT NULL

Overtime (Untitled22)

  • overtime_id (Key) — Primary key — NOT NULL
  • title (Field)
  • content (Field2)
  • overtime_date (Field3)
  • status (Field4)
  • created_by (Field5)
  • created_at (Field6)

Photo_Board (Untitled9)

  • photo_id (Key) — Primary key — NOT NULL
  • title (Field)
  • content (Field2)
  • created_by (Field3)
  • created_at (Field4)
  • attach_id (Key2) — Foreign key → Attach.attach_id — NOT NULL

Photo_Comment (Untitled11)

  • photo_id (Key) — Foreign key → Photo_Board.photo_id — NOT NULL
  • comment_id (Key2) — Foreign key → Comment.comment_id — NOT NULL

Photo_King (CopyOfUntitled26)

  • photo_comment_king_id (Key) — Primary key — NOT NULL
  • photo_count (Field2)
  • account_id (ㄹ) — Foreign key → Account.account_id — NOT NULL

Photo_Like (Untitled12)

  • photo_id (Key) — Foreign key → Photo_Board.photo_id — NOT NULL
  • account_id (ㄹ) — Foreign key → Account.account_id — NOT NULL

Request (Untitled14)

  • request_id (Key) — Primary key — NOT NULL
  • title (Field)
  • request_type (Field2)
  • content (Field3)
  • status (Field4)
  • created_by (Field5)
  • created_at (Field6)
  • approval_at (Field7)

Role (Untitled3)

  • role_id (Key) — Primary key — NOT NULL
  • name (Field)

Sign (Untitled15)

  • sign_id (Key) — Primary key — NOT NULL
  • signatory (Field)
  • orders (Field2)
  • status (Field3)
  • request_id (Key2) — Foreign key → Request.request_id — NOT NULL
  • vacation_id (Key3) — Foreign key → Vacation.vacation_id — NOT NULL
  • overtime_id (Key4) — Foreign key → Overtime.overtime_id — NOT NULL

Talk (Untitled30)

  • talk_id (Key) — Primary key — NOT NULL
  • content (Field)
  • created_by (Field3)

Team (Untitled)

  • team_id (Key) — Primary key — NOT NULL
  • name (Field)
  • leader (Field2)

Vacation (Untitled19)

  • vacation_id (Key) — Primary key — NOT NULL
  • title (Field)
  • content (Field5)
  • vacation_type (Field2)
  • status (Field8)
  • start_date (Field3)
  • end_date (Field4)
  • created_by (Field6)
  • created_at (Field7)

Work (Untitled17)

  • work_id (Key) — Primary key — NOT NULL
  • type (Field)
  • work_date (Field2)
  • created_by (Field4)
  • created_at (Field3)

Wrap_Comment (Untitled27)

  • wrap_comment (Key) — Primary key — NOT NULL
  • content (Field)
  • created_by (Field2)
  • created_at (Field3)